package com.ihrm.domain.employee;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class EmployeeTransferPositionExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public EmployeeTransferPositionExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andUserIdIsNull() {
            addCriterion("user_id is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("user_id is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(String value) {
            addCriterion("user_id =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(String value) {
            addCriterion("user_id <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(String value) {
            addCriterion("user_id >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("user_id >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(String value) {
            addCriterion("user_id <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(String value) {
            addCriterion("user_id <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLike(String value) {
            addCriterion("user_id like", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotLike(String value) {
            addCriterion("user_id not like", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<String> values) {
            addCriterion("user_id in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<String> values) {
            addCriterion("user_id not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(String value1, String value2) {
            addCriterion("user_id between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(String value1, String value2) {
            addCriterion("user_id not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andPostIsNull() {
            addCriterion("post is null");
            return (Criteria) this;
        }

        public Criteria andPostIsNotNull() {
            addCriterion("post is not null");
            return (Criteria) this;
        }

        public Criteria andPostEqualTo(String value) {
            addCriterion("post =", value, "post");
            return (Criteria) this;
        }

        public Criteria andPostNotEqualTo(String value) {
            addCriterion("post <>", value, "post");
            return (Criteria) this;
        }

        public Criteria andPostGreaterThan(String value) {
            addCriterion("post >", value, "post");
            return (Criteria) this;
        }

        public Criteria andPostGreaterThanOrEqualTo(String value) {
            addCriterion("post >=", value, "post");
            return (Criteria) this;
        }

        public Criteria andPostLessThan(String value) {
            addCriterion("post <", value, "post");
            return (Criteria) this;
        }

        public Criteria andPostLessThanOrEqualTo(String value) {
            addCriterion("post <=", value, "post");
            return (Criteria) this;
        }

        public Criteria andPostLike(String value) {
            addCriterion("post like", value, "post");
            return (Criteria) this;
        }

        public Criteria andPostNotLike(String value) {
            addCriterion("post not like", value, "post");
            return (Criteria) this;
        }

        public Criteria andPostIn(List<String> values) {
            addCriterion("post in", values, "post");
            return (Criteria) this;
        }

        public Criteria andPostNotIn(List<String> values) {
            addCriterion("post not in", values, "post");
            return (Criteria) this;
        }

        public Criteria andPostBetween(String value1, String value2) {
            addCriterion("post between", value1, value2, "post");
            return (Criteria) this;
        }

        public Criteria andPostNotBetween(String value1, String value2) {
            addCriterion("post not between", value1, value2, "post");
            return (Criteria) this;
        }

        public Criteria andRankIsNull() {
            addCriterion("rank is null");
            return (Criteria) this;
        }

        public Criteria andRankIsNotNull() {
            addCriterion("rank is not null");
            return (Criteria) this;
        }

        public Criteria andRankEqualTo(String value) {
            addCriterion("rank =", value, "rank");
            return (Criteria) this;
        }

        public Criteria andRankNotEqualTo(String value) {
            addCriterion("rank <>", value, "rank");
            return (Criteria) this;
        }

        public Criteria andRankGreaterThan(String value) {
            addCriterion("rank >", value, "rank");
            return (Criteria) this;
        }

        public Criteria andRankGreaterThanOrEqualTo(String value) {
            addCriterion("rank >=", value, "rank");
            return (Criteria) this;
        }

        public Criteria andRankLessThan(String value) {
            addCriterion("rank <", value, "rank");
            return (Criteria) this;
        }

        public Criteria andRankLessThanOrEqualTo(String value) {
            addCriterion("rank <=", value, "rank");
            return (Criteria) this;
        }

        public Criteria andRankLike(String value) {
            addCriterion("rank like", value, "rank");
            return (Criteria) this;
        }

        public Criteria andRankNotLike(String value) {
            addCriterion("rank not like", value, "rank");
            return (Criteria) this;
        }

        public Criteria andRankIn(List<String> values) {
            addCriterion("rank in", values, "rank");
            return (Criteria) this;
        }

        public Criteria andRankNotIn(List<String> values) {
            addCriterion("rank not in", values, "rank");
            return (Criteria) this;
        }

        public Criteria andRankBetween(String value1, String value2) {
            addCriterion("rank between", value1, value2, "rank");
            return (Criteria) this;
        }

        public Criteria andRankNotBetween(String value1, String value2) {
            addCriterion("rank not between", value1, value2, "rank");
            return (Criteria) this;
        }

        public Criteria andReportingObjectIsNull() {
            addCriterion("reporting_object is null");
            return (Criteria) this;
        }

        public Criteria andReportingObjectIsNotNull() {
            addCriterion("reporting_object is not null");
            return (Criteria) this;
        }

        public Criteria andReportingObjectEqualTo(String value) {
            addCriterion("reporting_object =", value, "reportingObject");
            return (Criteria) this;
        }

        public Criteria andReportingObjectNotEqualTo(String value) {
            addCriterion("reporting_object <>", value, "reportingObject");
            return (Criteria) this;
        }

        public Criteria andReportingObjectGreaterThan(String value) {
            addCriterion("reporting_object >", value, "reportingObject");
            return (Criteria) this;
        }

        public Criteria andReportingObjectGreaterThanOrEqualTo(String value) {
            addCriterion("reporting_object >=", value, "reportingObject");
            return (Criteria) this;
        }

        public Criteria andReportingObjectLessThan(String value) {
            addCriterion("reporting_object <", value, "reportingObject");
            return (Criteria) this;
        }

        public Criteria andReportingObjectLessThanOrEqualTo(String value) {
            addCriterion("reporting_object <=", value, "reportingObject");
            return (Criteria) this;
        }

        public Criteria andReportingObjectLike(String value) {
            addCriterion("reporting_object like", value, "reportingObject");
            return (Criteria) this;
        }

        public Criteria andReportingObjectNotLike(String value) {
            addCriterion("reporting_object not like", value, "reportingObject");
            return (Criteria) this;
        }

        public Criteria andReportingObjectIn(List<String> values) {
            addCriterion("reporting_object in", values, "reportingObject");
            return (Criteria) this;
        }

        public Criteria andReportingObjectNotIn(List<String> values) {
            addCriterion("reporting_object not in", values, "reportingObject");
            return (Criteria) this;
        }

        public Criteria andReportingObjectBetween(String value1, String value2) {
            addCriterion("reporting_object between", value1, value2, "reportingObject");
            return (Criteria) this;
        }

        public Criteria andReportingObjectNotBetween(String value1, String value2) {
            addCriterion("reporting_object not between", value1, value2, "reportingObject");
            return (Criteria) this;
        }

        public Criteria andHrbpIsNull() {
            addCriterion("hrbp is null");
            return (Criteria) this;
        }

        public Criteria andHrbpIsNotNull() {
            addCriterion("hrbp is not null");
            return (Criteria) this;
        }

        public Criteria andHrbpEqualTo(String value) {
            addCriterion("hrbp =", value, "hrbp");
            return (Criteria) this;
        }

        public Criteria andHrbpNotEqualTo(String value) {
            addCriterion("hrbp <>", value, "hrbp");
            return (Criteria) this;
        }

        public Criteria andHrbpGreaterThan(String value) {
            addCriterion("hrbp >", value, "hrbp");
            return (Criteria) this;
        }

        public Criteria andHrbpGreaterThanOrEqualTo(String value) {
            addCriterion("hrbp >=", value, "hrbp");
            return (Criteria) this;
        }

        public Criteria andHrbpLessThan(String value) {
            addCriterion("hrbp <", value, "hrbp");
            return (Criteria) this;
        }

        public Criteria andHrbpLessThanOrEqualTo(String value) {
            addCriterion("hrbp <=", value, "hrbp");
            return (Criteria) this;
        }

        public Criteria andHrbpLike(String value) {
            addCriterion("hrbp like", value, "hrbp");
            return (Criteria) this;
        }

        public Criteria andHrbpNotLike(String value) {
            addCriterion("hrbp not like", value, "hrbp");
            return (Criteria) this;
        }

        public Criteria andHrbpIn(List<String> values) {
            addCriterion("hrbp in", values, "hrbp");
            return (Criteria) this;
        }

        public Criteria andHrbpNotIn(List<String> values) {
            addCriterion("hrbp not in", values, "hrbp");
            return (Criteria) this;
        }

        public Criteria andHrbpBetween(String value1, String value2) {
            addCriterion("hrbp between", value1, value2, "hrbp");
            return (Criteria) this;
        }

        public Criteria andHrbpNotBetween(String value1, String value2) {
            addCriterion("hrbp not between", value1, value2, "hrbp");
            return (Criteria) this;
        }

        public Criteria andAdjustmentTimeIsNull() {
            addCriterion("adjustment_time is null");
            return (Criteria) this;
        }

        public Criteria andAdjustmentTimeIsNotNull() {
            addCriterion("adjustment_time is not null");
            return (Criteria) this;
        }

        public Criteria andAdjustmentTimeEqualTo(Date value) {
            addCriterion("adjustment_time =", value, "adjustmentTime");
            return (Criteria) this;
        }

        public Criteria andAdjustmentTimeNotEqualTo(Date value) {
            addCriterion("adjustment_time <>", value, "adjustmentTime");
            return (Criteria) this;
        }

        public Criteria andAdjustmentTimeGreaterThan(Date value) {
            addCriterion("adjustment_time >", value, "adjustmentTime");
            return (Criteria) this;
        }

        public Criteria andAdjustmentTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("adjustment_time >=", value, "adjustmentTime");
            return (Criteria) this;
        }

        public Criteria andAdjustmentTimeLessThan(Date value) {
            addCriterion("adjustment_time <", value, "adjustmentTime");
            return (Criteria) this;
        }

        public Criteria andAdjustmentTimeLessThanOrEqualTo(Date value) {
            addCriterion("adjustment_time <=", value, "adjustmentTime");
            return (Criteria) this;
        }

        public Criteria andAdjustmentTimeIn(List<Date> values) {
            addCriterion("adjustment_time in", values, "adjustmentTime");
            return (Criteria) this;
        }

        public Criteria andAdjustmentTimeNotIn(List<Date> values) {
            addCriterion("adjustment_time not in", values, "adjustmentTime");
            return (Criteria) this;
        }

        public Criteria andAdjustmentTimeBetween(Date value1, Date value2) {
            addCriterion("adjustment_time between", value1, value2, "adjustmentTime");
            return (Criteria) this;
        }

        public Criteria andAdjustmentTimeNotBetween(Date value1, Date value2) {
            addCriterion("adjustment_time not between", value1, value2, "adjustmentTime");
            return (Criteria) this;
        }

        public Criteria andCauseOfAdjustingPostIsNull() {
            addCriterion("cause_of_adjusting_post is null");
            return (Criteria) this;
        }

        public Criteria andCauseOfAdjustingPostIsNotNull() {
            addCriterion("cause_of_adjusting_post is not null");
            return (Criteria) this;
        }

        public Criteria andCauseOfAdjustingPostEqualTo(String value) {
            addCriterion("cause_of_adjusting_post =", value, "causeOfAdjustingPost");
            return (Criteria) this;
        }

        public Criteria andCauseOfAdjustingPostNotEqualTo(String value) {
            addCriterion("cause_of_adjusting_post <>", value, "causeOfAdjustingPost");
            return (Criteria) this;
        }

        public Criteria andCauseOfAdjustingPostGreaterThan(String value) {
            addCriterion("cause_of_adjusting_post >", value, "causeOfAdjustingPost");
            return (Criteria) this;
        }

        public Criteria andCauseOfAdjustingPostGreaterThanOrEqualTo(String value) {
            addCriterion("cause_of_adjusting_post >=", value, "causeOfAdjustingPost");
            return (Criteria) this;
        }

        public Criteria andCauseOfAdjustingPostLessThan(String value) {
            addCriterion("cause_of_adjusting_post <", value, "causeOfAdjustingPost");
            return (Criteria) this;
        }

        public Criteria andCauseOfAdjustingPostLessThanOrEqualTo(String value) {
            addCriterion("cause_of_adjusting_post <=", value, "causeOfAdjustingPost");
            return (Criteria) this;
        }

        public Criteria andCauseOfAdjustingPostLike(String value) {
            addCriterion("cause_of_adjusting_post like", value, "causeOfAdjustingPost");
            return (Criteria) this;
        }

        public Criteria andCauseOfAdjustingPostNotLike(String value) {
            addCriterion("cause_of_adjusting_post not like", value, "causeOfAdjustingPost");
            return (Criteria) this;
        }

        public Criteria andCauseOfAdjustingPostIn(List<String> values) {
            addCriterion("cause_of_adjusting_post in", values, "causeOfAdjustingPost");
            return (Criteria) this;
        }

        public Criteria andCauseOfAdjustingPostNotIn(List<String> values) {
            addCriterion("cause_of_adjusting_post not in", values, "causeOfAdjustingPost");
            return (Criteria) this;
        }

        public Criteria andCauseOfAdjustingPostBetween(String value1, String value2) {
            addCriterion("cause_of_adjusting_post between", value1, value2, "causeOfAdjustingPost");
            return (Criteria) this;
        }

        public Criteria andCauseOfAdjustingPostNotBetween(String value1, String value2) {
            addCriterion("cause_of_adjusting_post not between", value1, value2, "causeOfAdjustingPost");
            return (Criteria) this;
        }

        public Criteria andEnclosureIsNull() {
            addCriterion("enclosure is null");
            return (Criteria) this;
        }

        public Criteria andEnclosureIsNotNull() {
            addCriterion("enclosure is not null");
            return (Criteria) this;
        }

        public Criteria andEnclosureEqualTo(String value) {
            addCriterion("enclosure =", value, "enclosure");
            return (Criteria) this;
        }

        public Criteria andEnclosureNotEqualTo(String value) {
            addCriterion("enclosure <>", value, "enclosure");
            return (Criteria) this;
        }

        public Criteria andEnclosureGreaterThan(String value) {
            addCriterion("enclosure >", value, "enclosure");
            return (Criteria) this;
        }

        public Criteria andEnclosureGreaterThanOrEqualTo(String value) {
            addCriterion("enclosure >=", value, "enclosure");
            return (Criteria) this;
        }

        public Criteria andEnclosureLessThan(String value) {
            addCriterion("enclosure <", value, "enclosure");
            return (Criteria) this;
        }

        public Criteria andEnclosureLessThanOrEqualTo(String value) {
            addCriterion("enclosure <=", value, "enclosure");
            return (Criteria) this;
        }

        public Criteria andEnclosureLike(String value) {
            addCriterion("enclosure like", value, "enclosure");
            return (Criteria) this;
        }

        public Criteria andEnclosureNotLike(String value) {
            addCriterion("enclosure not like", value, "enclosure");
            return (Criteria) this;
        }

        public Criteria andEnclosureIn(List<String> values) {
            addCriterion("enclosure in", values, "enclosure");
            return (Criteria) this;
        }

        public Criteria andEnclosureNotIn(List<String> values) {
            addCriterion("enclosure not in", values, "enclosure");
            return (Criteria) this;
        }

        public Criteria andEnclosureBetween(String value1, String value2) {
            addCriterion("enclosure between", value1, value2, "enclosure");
            return (Criteria) this;
        }

        public Criteria andEnclosureNotBetween(String value1, String value2) {
            addCriterion("enclosure not between", value1, value2, "enclosure");
            return (Criteria) this;
        }

        public Criteria andFormOfManagementIsNull() {
            addCriterion("form_of_management is null");
            return (Criteria) this;
        }

        public Criteria andFormOfManagementIsNotNull() {
            addCriterion("form_of_management is not null");
            return (Criteria) this;
        }

        public Criteria andFormOfManagementEqualTo(String value) {
            addCriterion("form_of_management =", value, "formOfManagement");
            return (Criteria) this;
        }

        public Criteria andFormOfManagementNotEqualTo(String value) {
            addCriterion("form_of_management <>", value, "formOfManagement");
            return (Criteria) this;
        }

        public Criteria andFormOfManagementGreaterThan(String value) {
            addCriterion("form_of_management >", value, "formOfManagement");
            return (Criteria) this;
        }

        public Criteria andFormOfManagementGreaterThanOrEqualTo(String value) {
            addCriterion("form_of_management >=", value, "formOfManagement");
            return (Criteria) this;
        }

        public Criteria andFormOfManagementLessThan(String value) {
            addCriterion("form_of_management <", value, "formOfManagement");
            return (Criteria) this;
        }

        public Criteria andFormOfManagementLessThanOrEqualTo(String value) {
            addCriterion("form_of_management <=", value, "formOfManagement");
            return (Criteria) this;
        }

        public Criteria andFormOfManagementLike(String value) {
            addCriterion("form_of_management like", value, "formOfManagement");
            return (Criteria) this;
        }

        public Criteria andFormOfManagementNotLike(String value) {
            addCriterion("form_of_management not like", value, "formOfManagement");
            return (Criteria) this;
        }

        public Criteria andFormOfManagementIn(List<String> values) {
            addCriterion("form_of_management in", values, "formOfManagement");
            return (Criteria) this;
        }

        public Criteria andFormOfManagementNotIn(List<String> values) {
            addCriterion("form_of_management not in", values, "formOfManagement");
            return (Criteria) this;
        }

        public Criteria andFormOfManagementBetween(String value1, String value2) {
            addCriterion("form_of_management between", value1, value2, "formOfManagement");
            return (Criteria) this;
        }

        public Criteria andFormOfManagementNotBetween(String value1, String value2) {
            addCriterion("form_of_management not between", value1, value2, "formOfManagement");
            return (Criteria) this;
        }

        public Criteria andWorkingCityIsNull() {
            addCriterion("working_city is null");
            return (Criteria) this;
        }

        public Criteria andWorkingCityIsNotNull() {
            addCriterion("working_city is not null");
            return (Criteria) this;
        }

        public Criteria andWorkingCityEqualTo(String value) {
            addCriterion("working_city =", value, "workingCity");
            return (Criteria) this;
        }

        public Criteria andWorkingCityNotEqualTo(String value) {
            addCriterion("working_city <>", value, "workingCity");
            return (Criteria) this;
        }

        public Criteria andWorkingCityGreaterThan(String value) {
            addCriterion("working_city >", value, "workingCity");
            return (Criteria) this;
        }

        public Criteria andWorkingCityGreaterThanOrEqualTo(String value) {
            addCriterion("working_city >=", value, "workingCity");
            return (Criteria) this;
        }

        public Criteria andWorkingCityLessThan(String value) {
            addCriterion("working_city <", value, "workingCity");
            return (Criteria) this;
        }

        public Criteria andWorkingCityLessThanOrEqualTo(String value) {
            addCriterion("working_city <=", value, "workingCity");
            return (Criteria) this;
        }

        public Criteria andWorkingCityLike(String value) {
            addCriterion("working_city like", value, "workingCity");
            return (Criteria) this;
        }

        public Criteria andWorkingCityNotLike(String value) {
            addCriterion("working_city not like", value, "workingCity");
            return (Criteria) this;
        }

        public Criteria andWorkingCityIn(List<String> values) {
            addCriterion("working_city in", values, "workingCity");
            return (Criteria) this;
        }

        public Criteria andWorkingCityNotIn(List<String> values) {
            addCriterion("working_city not in", values, "workingCity");
            return (Criteria) this;
        }

        public Criteria andWorkingCityBetween(String value1, String value2) {
            addCriterion("working_city between", value1, value2, "workingCity");
            return (Criteria) this;
        }

        public Criteria andWorkingCityNotBetween(String value1, String value2) {
            addCriterion("working_city not between", value1, value2, "workingCity");
            return (Criteria) this;
        }

        public Criteria andTaxableCityIsNull() {
            addCriterion("taxable_city is null");
            return (Criteria) this;
        }

        public Criteria andTaxableCityIsNotNull() {
            addCriterion("taxable_city is not null");
            return (Criteria) this;
        }

        public Criteria andTaxableCityEqualTo(String value) {
            addCriterion("taxable_city =", value, "taxableCity");
            return (Criteria) this;
        }

        public Criteria andTaxableCityNotEqualTo(String value) {
            addCriterion("taxable_city <>", value, "taxableCity");
            return (Criteria) this;
        }

        public Criteria andTaxableCityGreaterThan(String value) {
            addCriterion("taxable_city >", value, "taxableCity");
            return (Criteria) this;
        }

        public Criteria andTaxableCityGreaterThanOrEqualTo(String value) {
            addCriterion("taxable_city >=", value, "taxableCity");
            return (Criteria) this;
        }

        public Criteria andTaxableCityLessThan(String value) {
            addCriterion("taxable_city <", value, "taxableCity");
            return (Criteria) this;
        }

        public Criteria andTaxableCityLessThanOrEqualTo(String value) {
            addCriterion("taxable_city <=", value, "taxableCity");
            return (Criteria) this;
        }

        public Criteria andTaxableCityLike(String value) {
            addCriterion("taxable_city like", value, "taxableCity");
            return (Criteria) this;
        }

        public Criteria andTaxableCityNotLike(String value) {
            addCriterion("taxable_city not like", value, "taxableCity");
            return (Criteria) this;
        }

        public Criteria andTaxableCityIn(List<String> values) {
            addCriterion("taxable_city in", values, "taxableCity");
            return (Criteria) this;
        }

        public Criteria andTaxableCityNotIn(List<String> values) {
            addCriterion("taxable_city not in", values, "taxableCity");
            return (Criteria) this;
        }

        public Criteria andTaxableCityBetween(String value1, String value2) {
            addCriterion("taxable_city between", value1, value2, "taxableCity");
            return (Criteria) this;
        }

        public Criteria andTaxableCityNotBetween(String value1, String value2) {
            addCriterion("taxable_city not between", value1, value2, "taxableCity");
            return (Criteria) this;
        }

        public Criteria andCurrentContractStartTimeIsNull() {
            addCriterion("current_contract_start_time is null");
            return (Criteria) this;
        }

        public Criteria andCurrentContractStartTimeIsNotNull() {
            addCriterion("current_contract_start_time is not null");
            return (Criteria) this;
        }

        public Criteria andCurrentContractStartTimeEqualTo(String value) {
            addCriterion("current_contract_start_time =", value, "currentContractStartTime");
            return (Criteria) this;
        }

        public Criteria andCurrentContractStartTimeNotEqualTo(String value) {
            addCriterion("current_contract_start_time <>", value, "currentContractStartTime");
            return (Criteria) this;
        }

        public Criteria andCurrentContractStartTimeGreaterThan(String value) {
            addCriterion("current_contract_start_time >", value, "currentContractStartTime");
            return (Criteria) this;
        }

        public Criteria andCurrentContractStartTimeGreaterThanOrEqualTo(String value) {
            addCriterion("current_contract_start_time >=", value, "currentContractStartTime");
            return (Criteria) this;
        }

        public Criteria andCurrentContractStartTimeLessThan(String value) {
            addCriterion("current_contract_start_time <", value, "currentContractStartTime");
            return (Criteria) this;
        }

        public Criteria andCurrentContractStartTimeLessThanOrEqualTo(String value) {
            addCriterion("current_contract_start_time <=", value, "currentContractStartTime");
            return (Criteria) this;
        }

        public Criteria andCurrentContractStartTimeLike(String value) {
            addCriterion("current_contract_start_time like", value, "currentContractStartTime");
            return (Criteria) this;
        }

        public Criteria andCurrentContractStartTimeNotLike(String value) {
            addCriterion("current_contract_start_time not like", value, "currentContractStartTime");
            return (Criteria) this;
        }

        public Criteria andCurrentContractStartTimeIn(List<String> values) {
            addCriterion("current_contract_start_time in", values, "currentContractStartTime");
            return (Criteria) this;
        }

        public Criteria andCurrentContractStartTimeNotIn(List<String> values) {
            addCriterion("current_contract_start_time not in", values, "currentContractStartTime");
            return (Criteria) this;
        }

        public Criteria andCurrentContractStartTimeBetween(String value1, String value2) {
            addCriterion("current_contract_start_time between", value1, value2, "currentContractStartTime");
            return (Criteria) this;
        }

        public Criteria andCurrentContractStartTimeNotBetween(String value1, String value2) {
            addCriterion("current_contract_start_time not between", value1, value2, "currentContractStartTime");
            return (Criteria) this;
        }

        public Criteria andClosingTimeOfCurrentContractIsNull() {
            addCriterion("closing_time_of_current_contract is null");
            return (Criteria) this;
        }

        public Criteria andClosingTimeOfCurrentContractIsNotNull() {
            addCriterion("closing_time_of_current_contract is not null");
            return (Criteria) this;
        }

        public Criteria andClosingTimeOfCurrentContractEqualTo(String value) {
            addCriterion("closing_time_of_current_contract =", value, "closingTimeOfCurrentContract");
            return (Criteria) this;
        }

        public Criteria andClosingTimeOfCurrentContractNotEqualTo(String value) {
            addCriterion("closing_time_of_current_contract <>", value, "closingTimeOfCurrentContract");
            return (Criteria) this;
        }

        public Criteria andClosingTimeOfCurrentContractGreaterThan(String value) {
            addCriterion("closing_time_of_current_contract >", value, "closingTimeOfCurrentContract");
            return (Criteria) this;
        }

        public Criteria andClosingTimeOfCurrentContractGreaterThanOrEqualTo(String value) {
            addCriterion("closing_time_of_current_contract >=", value, "closingTimeOfCurrentContract");
            return (Criteria) this;
        }

        public Criteria andClosingTimeOfCurrentContractLessThan(String value) {
            addCriterion("closing_time_of_current_contract <", value, "closingTimeOfCurrentContract");
            return (Criteria) this;
        }

        public Criteria andClosingTimeOfCurrentContractLessThanOrEqualTo(String value) {
            addCriterion("closing_time_of_current_contract <=", value, "closingTimeOfCurrentContract");
            return (Criteria) this;
        }

        public Criteria andClosingTimeOfCurrentContractLike(String value) {
            addCriterion("closing_time_of_current_contract like", value, "closingTimeOfCurrentContract");
            return (Criteria) this;
        }

        public Criteria andClosingTimeOfCurrentContractNotLike(String value) {
            addCriterion("closing_time_of_current_contract not like", value, "closingTimeOfCurrentContract");
            return (Criteria) this;
        }

        public Criteria andClosingTimeOfCurrentContractIn(List<String> values) {
            addCriterion("closing_time_of_current_contract in", values, "closingTimeOfCurrentContract");
            return (Criteria) this;
        }

        public Criteria andClosingTimeOfCurrentContractNotIn(List<String> values) {
            addCriterion("closing_time_of_current_contract not in", values, "closingTimeOfCurrentContract");
            return (Criteria) this;
        }

        public Criteria andClosingTimeOfCurrentContractBetween(String value1, String value2) {
            addCriterion("closing_time_of_current_contract between", value1, value2, "closingTimeOfCurrentContract");
            return (Criteria) this;
        }

        public Criteria andClosingTimeOfCurrentContractNotBetween(String value1, String value2) {
            addCriterion("closing_time_of_current_contract not between", value1, value2, "closingTimeOfCurrentContract");
            return (Criteria) this;
        }

        public Criteria andWorkingPlaceIsNull() {
            addCriterion("working_place is null");
            return (Criteria) this;
        }

        public Criteria andWorkingPlaceIsNotNull() {
            addCriterion("working_place is not null");
            return (Criteria) this;
        }

        public Criteria andWorkingPlaceEqualTo(String value) {
            addCriterion("working_place =", value, "workingPlace");
            return (Criteria) this;
        }

        public Criteria andWorkingPlaceNotEqualTo(String value) {
            addCriterion("working_place <>", value, "workingPlace");
            return (Criteria) this;
        }

        public Criteria andWorkingPlaceGreaterThan(String value) {
            addCriterion("working_place >", value, "workingPlace");
            return (Criteria) this;
        }

        public Criteria andWorkingPlaceGreaterThanOrEqualTo(String value) {
            addCriterion("working_place >=", value, "workingPlace");
            return (Criteria) this;
        }

        public Criteria andWorkingPlaceLessThan(String value) {
            addCriterion("working_place <", value, "workingPlace");
            return (Criteria) this;
        }

        public Criteria andWorkingPlaceLessThanOrEqualTo(String value) {
            addCriterion("working_place <=", value, "workingPlace");
            return (Criteria) this;
        }

        public Criteria andWorkingPlaceLike(String value) {
            addCriterion("working_place like", value, "workingPlace");
            return (Criteria) this;
        }

        public Criteria andWorkingPlaceNotLike(String value) {
            addCriterion("working_place not like", value, "workingPlace");
            return (Criteria) this;
        }

        public Criteria andWorkingPlaceIn(List<String> values) {
            addCriterion("working_place in", values, "workingPlace");
            return (Criteria) this;
        }

        public Criteria andWorkingPlaceNotIn(List<String> values) {
            addCriterion("working_place not in", values, "workingPlace");
            return (Criteria) this;
        }

        public Criteria andWorkingPlaceBetween(String value1, String value2) {
            addCriterion("working_place between", value1, value2, "workingPlace");
            return (Criteria) this;
        }

        public Criteria andWorkingPlaceNotBetween(String value1, String value2) {
            addCriterion("working_place not between", value1, value2, "workingPlace");
            return (Criteria) this;
        }

        public Criteria andInitialContractStartTimeIsNull() {
            addCriterion("initial_contract_start_time is null");
            return (Criteria) this;
        }

        public Criteria andInitialContractStartTimeIsNotNull() {
            addCriterion("initial_contract_start_time is not null");
            return (Criteria) this;
        }

        public Criteria andInitialContractStartTimeEqualTo(String value) {
            addCriterion("initial_contract_start_time =", value, "initialContractStartTime");
            return (Criteria) this;
        }

        public Criteria andInitialContractStartTimeNotEqualTo(String value) {
            addCriterion("initial_contract_start_time <>", value, "initialContractStartTime");
            return (Criteria) this;
        }

        public Criteria andInitialContractStartTimeGreaterThan(String value) {
            addCriterion("initial_contract_start_time >", value, "initialContractStartTime");
            return (Criteria) this;
        }

        public Criteria andInitialContractStartTimeGreaterThanOrEqualTo(String value) {
            addCriterion("initial_contract_start_time >=", value, "initialContractStartTime");
            return (Criteria) this;
        }

        public Criteria andInitialContractStartTimeLessThan(String value) {
            addCriterion("initial_contract_start_time <", value, "initialContractStartTime");
            return (Criteria) this;
        }

        public Criteria andInitialContractStartTimeLessThanOrEqualTo(String value) {
            addCriterion("initial_contract_start_time <=", value, "initialContractStartTime");
            return (Criteria) this;
        }

        public Criteria andInitialContractStartTimeLike(String value) {
            addCriterion("initial_contract_start_time like", value, "initialContractStartTime");
            return (Criteria) this;
        }

        public Criteria andInitialContractStartTimeNotLike(String value) {
            addCriterion("initial_contract_start_time not like", value, "initialContractStartTime");
            return (Criteria) this;
        }

        public Criteria andInitialContractStartTimeIn(List<String> values) {
            addCriterion("initial_contract_start_time in", values, "initialContractStartTime");
            return (Criteria) this;
        }

        public Criteria andInitialContractStartTimeNotIn(List<String> values) {
            addCriterion("initial_contract_start_time not in", values, "initialContractStartTime");
            return (Criteria) this;
        }

        public Criteria andInitialContractStartTimeBetween(String value1, String value2) {
            addCriterion("initial_contract_start_time between", value1, value2, "initialContractStartTime");
            return (Criteria) this;
        }

        public Criteria andInitialContractStartTimeNotBetween(String value1, String value2) {
            addCriterion("initial_contract_start_time not between", value1, value2, "initialContractStartTime");
            return (Criteria) this;
        }

        public Criteria andFirstContractTerminationTimeIsNull() {
            addCriterion("first_contract_termination_time is null");
            return (Criteria) this;
        }

        public Criteria andFirstContractTerminationTimeIsNotNull() {
            addCriterion("first_contract_termination_time is not null");
            return (Criteria) this;
        }

        public Criteria andFirstContractTerminationTimeEqualTo(String value) {
            addCriterion("first_contract_termination_time =", value, "firstContractTerminationTime");
            return (Criteria) this;
        }

        public Criteria andFirstContractTerminationTimeNotEqualTo(String value) {
            addCriterion("first_contract_termination_time <>", value, "firstContractTerminationTime");
            return (Criteria) this;
        }

        public Criteria andFirstContractTerminationTimeGreaterThan(String value) {
            addCriterion("first_contract_termination_time >", value, "firstContractTerminationTime");
            return (Criteria) this;
        }

        public Criteria andFirstContractTerminationTimeGreaterThanOrEqualTo(String value) {
            addCriterion("first_contract_termination_time >=", value, "firstContractTerminationTime");
            return (Criteria) this;
        }

        public Criteria andFirstContractTerminationTimeLessThan(String value) {
            addCriterion("first_contract_termination_time <", value, "firstContractTerminationTime");
            return (Criteria) this;
        }

        public Criteria andFirstContractTerminationTimeLessThanOrEqualTo(String value) {
            addCriterion("first_contract_termination_time <=", value, "firstContractTerminationTime");
            return (Criteria) this;
        }

        public Criteria andFirstContractTerminationTimeLike(String value) {
            addCriterion("first_contract_termination_time like", value, "firstContractTerminationTime");
            return (Criteria) this;
        }

        public Criteria andFirstContractTerminationTimeNotLike(String value) {
            addCriterion("first_contract_termination_time not like", value, "firstContractTerminationTime");
            return (Criteria) this;
        }

        public Criteria andFirstContractTerminationTimeIn(List<String> values) {
            addCriterion("first_contract_termination_time in", values, "firstContractTerminationTime");
            return (Criteria) this;
        }

        public Criteria andFirstContractTerminationTimeNotIn(List<String> values) {
            addCriterion("first_contract_termination_time not in", values, "firstContractTerminationTime");
            return (Criteria) this;
        }

        public Criteria andFirstContractTerminationTimeBetween(String value1, String value2) {
            addCriterion("first_contract_termination_time between", value1, value2, "firstContractTerminationTime");
            return (Criteria) this;
        }

        public Criteria andFirstContractTerminationTimeNotBetween(String value1, String value2) {
            addCriterion("first_contract_termination_time not between", value1, value2, "firstContractTerminationTime");
            return (Criteria) this;
        }

        public Criteria andContractPeriodIsNull() {
            addCriterion("contract_period is null");
            return (Criteria) this;
        }

        public Criteria andContractPeriodIsNotNull() {
            addCriterion("contract_period is not null");
            return (Criteria) this;
        }

        public Criteria andContractPeriodEqualTo(String value) {
            addCriterion("contract_period =", value, "contractPeriod");
            return (Criteria) this;
        }

        public Criteria andContractPeriodNotEqualTo(String value) {
            addCriterion("contract_period <>", value, "contractPeriod");
            return (Criteria) this;
        }

        public Criteria andContractPeriodGreaterThan(String value) {
            addCriterion("contract_period >", value, "contractPeriod");
            return (Criteria) this;
        }

        public Criteria andContractPeriodGreaterThanOrEqualTo(String value) {
            addCriterion("contract_period >=", value, "contractPeriod");
            return (Criteria) this;
        }

        public Criteria andContractPeriodLessThan(String value) {
            addCriterion("contract_period <", value, "contractPeriod");
            return (Criteria) this;
        }

        public Criteria andContractPeriodLessThanOrEqualTo(String value) {
            addCriterion("contract_period <=", value, "contractPeriod");
            return (Criteria) this;
        }

        public Criteria andContractPeriodLike(String value) {
            addCriterion("contract_period like", value, "contractPeriod");
            return (Criteria) this;
        }

        public Criteria andContractPeriodNotLike(String value) {
            addCriterion("contract_period not like", value, "contractPeriod");
            return (Criteria) this;
        }

        public Criteria andContractPeriodIn(List<String> values) {
            addCriterion("contract_period in", values, "contractPeriod");
            return (Criteria) this;
        }

        public Criteria andContractPeriodNotIn(List<String> values) {
            addCriterion("contract_period not in", values, "contractPeriod");
            return (Criteria) this;
        }

        public Criteria andContractPeriodBetween(String value1, String value2) {
            addCriterion("contract_period between", value1, value2, "contractPeriod");
            return (Criteria) this;
        }

        public Criteria andContractPeriodNotBetween(String value1, String value2) {
            addCriterion("contract_period not between", value1, value2, "contractPeriod");
            return (Criteria) this;
        }

        public Criteria andRenewalNumberIsNull() {
            addCriterion("renewal_number is null");
            return (Criteria) this;
        }

        public Criteria andRenewalNumberIsNotNull() {
            addCriterion("renewal_number is not null");
            return (Criteria) this;
        }

        public Criteria andRenewalNumberEqualTo(Integer value) {
            addCriterion("renewal_number =", value, "renewalNumber");
            return (Criteria) this;
        }

        public Criteria andRenewalNumberNotEqualTo(Integer value) {
            addCriterion("renewal_number <>", value, "renewalNumber");
            return (Criteria) this;
        }

        public Criteria andRenewalNumberGreaterThan(Integer value) {
            addCriterion("renewal_number >", value, "renewalNumber");
            return (Criteria) this;
        }

        public Criteria andRenewalNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("renewal_number >=", value, "renewalNumber");
            return (Criteria) this;
        }

        public Criteria andRenewalNumberLessThan(Integer value) {
            addCriterion("renewal_number <", value, "renewalNumber");
            return (Criteria) this;
        }

        public Criteria andRenewalNumberLessThanOrEqualTo(Integer value) {
            addCriterion("renewal_number <=", value, "renewalNumber");
            return (Criteria) this;
        }

        public Criteria andRenewalNumberIn(List<Integer> values) {
            addCriterion("renewal_number in", values, "renewalNumber");
            return (Criteria) this;
        }

        public Criteria andRenewalNumberNotIn(List<Integer> values) {
            addCriterion("renewal_number not in", values, "renewalNumber");
            return (Criteria) this;
        }

        public Criteria andRenewalNumberBetween(Integer value1, Integer value2) {
            addCriterion("renewal_number between", value1, value2, "renewalNumber");
            return (Criteria) this;
        }

        public Criteria andRenewalNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("renewal_number not between", value1, value2, "renewalNumber");
            return (Criteria) this;
        }

        public Criteria andRecommenderBusinessPeopleIsNull() {
            addCriterion("recommender_business_people is null");
            return (Criteria) this;
        }

        public Criteria andRecommenderBusinessPeopleIsNotNull() {
            addCriterion("recommender_business_people is not null");
            return (Criteria) this;
        }

        public Criteria andRecommenderBusinessPeopleEqualTo(String value) {
            addCriterion("recommender_business_people =", value, "recommenderBusinessPeople");
            return (Criteria) this;
        }

        public Criteria andRecommenderBusinessPeopleNotEqualTo(String value) {
            addCriterion("recommender_business_people <>", value, "recommenderBusinessPeople");
            return (Criteria) this;
        }

        public Criteria andRecommenderBusinessPeopleGreaterThan(String value) {
            addCriterion("recommender_business_people >", value, "recommenderBusinessPeople");
            return (Criteria) this;
        }

        public Criteria andRecommenderBusinessPeopleGreaterThanOrEqualTo(String value) {
            addCriterion("recommender_business_people >=", value, "recommenderBusinessPeople");
            return (Criteria) this;
        }

        public Criteria andRecommenderBusinessPeopleLessThan(String value) {
            addCriterion("recommender_business_people <", value, "recommenderBusinessPeople");
            return (Criteria) this;
        }

        public Criteria andRecommenderBusinessPeopleLessThanOrEqualTo(String value) {
            addCriterion("recommender_business_people <=", value, "recommenderBusinessPeople");
            return (Criteria) this;
        }

        public Criteria andRecommenderBusinessPeopleLike(String value) {
            addCriterion("recommender_business_people like", value, "recommenderBusinessPeople");
            return (Criteria) this;
        }

        public Criteria andRecommenderBusinessPeopleNotLike(String value) {
            addCriterion("recommender_business_people not like", value, "recommenderBusinessPeople");
            return (Criteria) this;
        }

        public Criteria andRecommenderBusinessPeopleIn(List<String> values) {
            addCriterion("recommender_business_people in", values, "recommenderBusinessPeople");
            return (Criteria) this;
        }

        public Criteria andRecommenderBusinessPeopleNotIn(List<String> values) {
            addCriterion("recommender_business_people not in", values, "recommenderBusinessPeople");
            return (Criteria) this;
        }

        public Criteria andRecommenderBusinessPeopleBetween(String value1, String value2) {
            addCriterion("recommender_business_people between", value1, value2, "recommenderBusinessPeople");
            return (Criteria) this;
        }

        public Criteria andRecommenderBusinessPeopleNotBetween(String value1, String value2) {
            addCriterion("recommender_business_people not between", value1, value2, "recommenderBusinessPeople");
            return (Criteria) this;
        }

        public Criteria andEstatusIsNull() {
            addCriterion("estatus is null");
            return (Criteria) this;
        }

        public Criteria andEstatusIsNotNull() {
            addCriterion("estatus is not null");
            return (Criteria) this;
        }

        public Criteria andEstatusEqualTo(Integer value) {
            addCriterion("estatus =", value, "estatus");
            return (Criteria) this;
        }

        public Criteria andEstatusNotEqualTo(Integer value) {
            addCriterion("estatus <>", value, "estatus");
            return (Criteria) this;
        }

        public Criteria andEstatusGreaterThan(Integer value) {
            addCriterion("estatus >", value, "estatus");
            return (Criteria) this;
        }

        public Criteria andEstatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("estatus >=", value, "estatus");
            return (Criteria) this;
        }

        public Criteria andEstatusLessThan(Integer value) {
            addCriterion("estatus <", value, "estatus");
            return (Criteria) this;
        }

        public Criteria andEstatusLessThanOrEqualTo(Integer value) {
            addCriterion("estatus <=", value, "estatus");
            return (Criteria) this;
        }

        public Criteria andEstatusIn(List<Integer> values) {
            addCriterion("estatus in", values, "estatus");
            return (Criteria) this;
        }

        public Criteria andEstatusNotIn(List<Integer> values) {
            addCriterion("estatus not in", values, "estatus");
            return (Criteria) this;
        }

        public Criteria andEstatusBetween(Integer value1, Integer value2) {
            addCriterion("estatus between", value1, value2, "estatus");
            return (Criteria) this;
        }

        public Criteria andEstatusNotBetween(Integer value1, Integer value2) {
            addCriterion("estatus not between", value1, value2, "estatus");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}